Melissa Yamada
Melissa Yamada
-
Re: Override Column Formula
Hello @wispsofsmoke You can follow @Paul Newcome's formula. You just need to add the additional IF statement at the first part of your formula to check whether the Date Override column is blank or no…1 · -
Re: Override Column Formula
Hello @wispsofsmoke A work around is to create a helper column (Date Override column) then on your main column with the column formula you can add an IF statement that if there is date in the "D…1 · -
Re: Nested IF with IF(OR statement not working
@JAAS What happened is your first IF statement should be an individual IF statement without the OR since they have individual logic when the statement is true and we'll need to adjust the number of c…1 · -
Re: How to display a list of cell values in a report based on certain criteria
Hello @Kpyto71 , I'd be happy to help! Create a row report. Select both sheets (Sheet 1 and Sheet 2) as your "Source Sheets" Select only necessary columns to show (For example: Name of the …1 · -
Re: How Do I Illustrate Checklist Data in a Dashboard?
Hi @megtro610 , I'd be happy to help! First, create a Metric Sheet (new sheet) and use cross sheet formulas to count for: Implemented and Evidence Attached Formula: =COUNTIFS({Is it implemented?}, 1,…2 ·
